Click Here!
home account info subscribe login search My ITKnowledge FAQ/help site map contact us


 
Brief Full
 Advanced
      Search
 Search Tips
To access the contents, click the chapter and section titles.

Oracle Performance Tuning and Optimization
(Publisher: Macmillan Computer Publishing)
Author(s): Edward Whalen
ISBN: 067230886x
Publication Date: 04/01/96

Bookmark It

Search this book:
 
Previous Table of Contents Next


Parallel Server Option

The Oracle Parallel Server option allows for two or more systems to access the same database tables by using a shared-disk mechanism. The option can be used both for increasing performance by adding more computers and for fault tolerance. If a hardware failure occurs in a parallel server configuration, the other members of the cluster continue running and automatically roll back any transactions that were pending on the failed system. The Parallel Server option is not available on all platforms; it requires special hardware and operating system support.

Oracle Symmetric Replication

Symmetric Replication is a new option introduced in Oracle version 7.2. It allows for replication of tables in a configuration so that all copies of the table can be modified. Data consistency is guaranteed through a complex set of rules. Full tables or subsets of tables can be replicated.

Trusted Oracle

Trusted Oracle is Oracle’s secure database management system product, designed to provide the high level of security required by companies and government agencies that handle sensitive data. Trusted Oracle is compatible with all the base Oracle products and supports all the functionality of standard Oracle. Trusted Oracle enforces mandatory access control across a wide range of secure operating systems. Trusted Oracle is not available on all platforms; it reduces performance because of the extra overhead associated with access control.

Parallel Query Option

The Parallel Query option is a set of features that allows a single query or operation to be divided among many processes. This feature can significantly improve performance in both multiprocessor and single-processor environments. Performance is increased by ensuring that the system CPUs stay busy doing work while other processes are waiting for I/Os to complete. The Parallel Query option is made up of the following components:

  Parallel Query: Allows SQL queries to be split into different components and to execute in parallel.
  Parallel Recovery: Performs instance recovery in parallel, greatly reducing the time it takes to recover from a system failure.
  Parallel Index Creation: Allows for indexes to be built in parallel, reducing index-creation time.
  Parallel Load: If you can separate load data into multiple files, you greatly reduce load time by allowing parallel load threads.
  Parallel Backup: Allows multiple backup streams from the same table.

Server Manager

The Oracle Server Manager provides a GUI tool for the administration of your Oracle RDBMS. Server Manager is available for Windows and Motif; a non-GUI, character-based version of this application is also available. Server Manager is intended to eventually replace SQL*DBA.

Oracle Workgroup Server

Workgroup Server is a powerful combination of the Oracle version 7 RDBMS and a complete set of point-and-click GUI tools that simplify database management. The Oracle version 7 Workgroup Server is part of the Workgroup/2000 suite of client/server tools. Workgroup Server comes preconfigured and is easy to install. The core RDBMS shipped with Workgroup Server is identical to the RDBMS shipped with the standard product. Some high-end add-ons (such as the Parallel Query option and the Distributed option) are not available on the Oracle Workgroup Server.

Workgroup Server is available on all major PC servers, including NetWare, NetWare NT, Solaris x86, SCO UNIX, Novell NetWare, and OS/2. As the PC server platform continues to increase in performance and reliability, the Oracle Workgroup Server provides an unbeatable value.

Here are some of the standard tools included with Workgroup Server:

  Database Manager: Manages the instance, including startup, shutdown, and configuration.
  User Manager: Manages user accounts and access security.
  Database Expander: Expands the database as needed without shutting the system down.
  Object Manager: Displays information about the database tables, indexes, and synonyms. Tables, indexes, and synonyms can be created from within the Object Manager.
  Miscellaneous tools: Tools such as Import, Export, Loader, and so on are also included.

The tools provided with Workgroup Server have the same look and feel whether your platform is a Windows NT system or UNIX system using X-Windows.

Personal Oracle for Windows

The newly released product, Personal Oracle for Windows, provides a version of the Oracle RDBMS for Microsoft Windows. With Personal Oracle for Windows, you can take Oracle with you on your notebook computer and use SQL*Net to connect to any other Oracle system on your network. Personal Oracle for Windows includes some of the same management tools shipped with Oracle Workgroup Server.

Oracle Development Tools

Oracle offers a rich set of development tools for use in GUI environments as well as character-based applications. These tools offer several approaches to application development based on the end user’s needs. Here’s a list of the development tools available:

  Developer/2000 and Designer/2000: Developer/2000 and Designer/2000 are the evolution of the Oracle CDE (Cooperative Development Environment) tools. Developer/2000 is a set of tools that allows the developer to create an application and roll it out in Windows, Macintosh, Motif, and character mode. Developer/2000 incorporates graphics and images as well as support for multimedia objects such as video and sound in a variety of standard formats. Designer/2000 is a set of design tools that assists you with process and data modeling; you can use Designer/2000 to provide input into the Developer/2000 system. Designer/2000 can be used to develop the fundamental models that are the foundation for your business processes.
  Power Objects: Power Objects is a lightweight GUI development tool designed to allow quick development of applications; Power Objects uses relatively few system resources. Power Objects is similar to Developer/2000 in concept—but without a lot of its features. Power Objects is available for Windows, Macintosh, and OS/2.
  Objects for OLE: Objects for OLE is a set of tools that allows you to link OLE-compliant applications to an Oracle RDBMS. This tool provides a quick and easy way to take advantage of the power of applications such as spreadsheets. Objects for OLE also allows for easy linking of database tables into word processing documents.


Previous Table of Contents Next


Products |  Contact Us |  About Us |  Privacy  |  Ad Info  |  Home

Use of this site is subject to certain Terms & Conditions, Copyright © 1996-2000 EarthWeb Inc.
All rights reserved. Reproduction whole or in part in any form or medium without express written permission of EarthWeb is prohibited.